package com.yu.mapper;

import com.yu.controller.dto.StuAdmissionData;
import com.yu.controller.dto.StuAge;
import com.yu.controller.dto.StuDateAnalysisModel;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StuScreenMapper {
    List<StuDateAnalysisModel> fnameSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    List<StuAge> ageSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    List<StuDateAnalysisModel> sexSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    List<StuDateAnalysisModel> majorSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    List<StuAdmissionData> stuAdmissionDataSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    List<StuDateAnalysisModel> stuMapSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    Integer totalCountSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
    Integer admissionCountSelect(@Param("admissionyear") int admissionyear, @Param("academy")String academy);
}
